package com.neusoft.weekreport.mapper;

import com.neusoft.weekreport.component.entities.ImportExcelAllUserInfo;
import com.neusoft.weekreport.component.entities.SendExcelUserInfo;
import com.neusoft.weekreport.component.req.GetExportExcelReq;

import java.util.List;
import java.util.Map;

public interface ExportExcelMapper {

    List<SendExcelUserInfo> selectByDept(GetExportExcelReq req);

    List<SendExcelUserInfo> selectByGroup(GetExportExcelReq req);

    List<SendExcelUserInfo> selectByDay(GetExportExcelReq req);

    List<Map<String,String>> selectByProject(GetExportExcelReq req);

    List<Map<String,String>> selectByTask(GetExportExcelReq req);

    List<Map<String,String>> selectByHour(GetExportExcelReq req);

    List<Map<String,String>> selectByResult(GetExportExcelReq req);

    List<Map<String,String>> selectByWay(GetExportExcelReq req);

    String selectByTime(GetExportExcelReq req);

    //按月导出
    List<SendExcelUserInfo> selectByMonth(GetExportExcelReq req);

    List<Map<String,String>> selectByMonthProject(GetExportExcelReq req);

    List<Map<String,String>> selectByMonthTask(GetExportExcelReq req);

    List<Map<String,String>> selectByMonthResult(GetExportExcelReq req);

    List<Map<String,String>> selectByMonthWay(GetExportExcelReq req);

    String selectByMonthTime(GetExportExcelReq req);

    //一次查出所有人当月数据
    List<ImportExcelAllUserInfo> selectAllMonth(GetExportExcelReq req);
}
